home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 17 / Developer Source Volume 17 (I-MODE Publications, Inc.)(2000).iso / oracl / mar97 / koopf107.gif < prev    next >
Graphics Interchange Format  |  1998-02-10  |  18.0 KB  |  632x229  |  4-bit (15 colors)
   ocr: FIGURE 7: Using B-Tree indexes can result in wasted blocks in your index. This shows the report results after insertion of 10,000 rows. blkixchk.sql Alloc. B leaf Avg. leof Blocks Avg. Dota Blocks Distinct Number Pct. Cluster Index Uniqueness Blocks level Blocks per Key per Key Keys of Rows Clustering for Rows Estimole Statistics: KOOPMI.TESTI, PK UNIQUE 515 1 94 1 1 10,442 9,998 116 1.16 UKOOPMI.TESTI_ _PLAUDT_DT NONUNIQUE 65 1 49 1 1 379 9,998 112 1.12 Compute Stalistics: JKOOPMI.TESTI PK UNIQUE 515 1 90 1 1 9,998 9,998 112 1.12 KOOPMILIEST.ALAUDL.DT NONUNIQUE 65 1 49 1 1 379 9,998 112 1.12 ...